insert overwrite table jms_dim.dim_yl_tms_bulk_cargo_shift_base
select
     id                          as  id
    ,region                      as  region_name
    ,region_code                 as  region_code
    ,province                    as  province_name
    ,province_code               as  province_code
    ,agent                       as  agent_name
    ,agent_code                  as  agent_code
    ,trans_shipment_center       as  center_name
    ,trans_shipment_center_code  as  center_code
    ,city                        as  city_name
    ,city_code                   as  city_code
    ,area                        as  area_name
    ,area_code                   as  area_code
    ,first_shift                 as  first_shift
    ,second_shift                as  second_shift
    ,create_time                 as  create_time
    ,create_by                   as  create_by
    ,modify_time                 as  modify_time
    ,modify_by                   as  modify_by
    ,effective_start_time        as  effective_start_time
    ,effective_end_time          as  effective_end_time
    ,deliver_span_day            as  deliver_span_day
    ,deliver_over_time           as  deliver_over_time
from jms_ods.tab_bulk_cargo_shift
where dt = '{{ execution_date | cst_ds }}'

                   
                   